USE PMURegistry
GO

INSERT INTO ContactType ([Name],[Description]) VALUES ('Business','Business Contact')
INSERT INTO ContactType ([Name],[Description]) VALUES ('Technical','Technical Contact')

INSERT INTO DeviceStatus ([Name],[Description]) VALUES ('Operational','')
INSERT INTO DeviceStatus ([Name],[Description]) VALUES ('Out of Service','')
INSERT INTO DeviceStatus ([Name],[Description]) VALUES ('Validated','')
INSERT INTO DeviceStatus ([Name],[Description]) VALUES ('In Progress','')
INSERT INTO DeviceStatus ([Name],[Description]) VALUES ('Planned','')
INSERT INTO DeviceStatus ([Name],[Description]) VALUES ('Retired','')

INSERT INTO Interconnection (Acronym, [Name]) VALUES ('Eastern', 'Eastern Interconnection')
INSERT INTO Interconnection (Acronym, [Name]) VALUES ('Western', 'Western Interconnection')
INSERT INTO Interconnection (Acronym, [Name]) VALUES ('ERCOT', 'Texas Interconnection')
INSERT INTO Interconnection (Acronym, [Name]) VALUES ('Quebec', 'Quebec Interconnection')
INSERT INTO Interconnection (Acronym, [Name]) VALUES ('Alaskan', 'Alaskan Interconnection')
INSERT INTO Interconnection (Acronym, [Name]) VALUES ('Hawaii', 'Hawaii Interconnection')

INSERT INTO NercRegion ([Name], [Description]) VALUES ('ERCOT','ERCOT ISO')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('FRCC','Florida Light & Power')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('TE','Hydro Quebec, TransEnergie')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('ICTE','Independent Coordinator Transmission - Entergy')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('ISNE','ISO New England Inc.')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('MISO','Midwest ISO')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('NBSO','New Brunswick System Operator')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('NYIS','New York Independent System Operator')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('ONT','Ontario - Independent Electricity System Operator')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('PNSC','Pacific Northwest Reliability Coordinator')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('PJM','PJM Interconnection')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('RDRC','Rocky Desert Reliability Coordinator')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('SPC','Saskatchewan Power Corporation')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('SOCO','Southern Company Services, Inc.')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('SWPP','Southwest Power Pool')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('TVA','Tennessee Valley Authority')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('VACS','VACAR - South')
INSERT INTO NercRegion ([Name], [Description]) VALUES ('WECC','WECC Reliability Coordinator')

INSERT INTO Protocol (Acronym, [Name]) VALUES ('BpaPdcStream', 'BPA PDCStream')
INSERT INTO Protocol (Acronym, [Name]) VALUES ('OPC', 'OPC')
INSERT INTO Protocol (Acronym, [Name]) VALUES ('Ieee1344', 'IEEE 1344-1995')
INSERT INTO Protocol (Acronym, [Name]) VALUES ('IeeeC37_118D6', 'IEEE C37.118 Draft 6')
INSERT INTO Protocol (Acronym, [Name]) VALUES ('IeeeC37_118V1', 'IEEE C37.118-2005')
INSERT INTO Protocol (Acronym, [Name]) VALUES ('FNet', 'Virginia Tech FNET')
INSERT INTO Protocol (Acronym, [Name]) VALUES ('SelFastMessage', 'SEL Fast Message')
INSERT INTO Protocol (Acronym, [Name]) VALUES ('Macrodyne', 'Macrodyne')

INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Current Magnitude', 'IPHM', 'PM', 'I', 'Phasor', 'Amps')
INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Current Phase Angle', 'IPHA', 'PA', 'IH', 'Phasor', 'Degrees')
INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Voltage Magnitude', 'VPHM', 'PM', 'V', 'Phasor', 'Volts')
INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Voltage Phase Angle', 'VPHA', 'PA', 'VH', 'Phasor', 'Degrees')
INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Frequency', 'FREQ', 'FQ', 'F', 'PMU', 'Hz')
INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Frequency Delta (dF/dt)', 'DFDT', 'DF', 'DF', 'PMU', '')
INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Analog Value', 'ALOG', 'AV', 'A', 'PMU', '')
INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Status Flags', 'STAT', 'SF', 'S', 'PMU', '')
INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Digital Value', 'DIGI', 'DV', 'D', 'PMU', '')
INSERT INTO SignalType(Name, Acronym, Suffix, Abbreviation, Source, EngineeringUnits) VALUES('Calculated Value', 'CALC', 'CV', 'C', 'PMU', '')

INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('ABB', 'ABB', '', '', 'http://www.abb.com/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('ARB', 'Arbiter', '', '', 'http://www.arbiter.com/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('ATK', 'Ametek', '', '', 'http://www.ametek.com/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('BPA', 'Bonneville Power Administration', '', '', 'http://www.bpa.gov/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('GE', 'General Electric', '', '', 'http://www.ge.com/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('HWY', 'Hathaway', '', '', 'http://www.qualitrolcorp.com/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('MAC', 'Macrodyne', '', '', 'http://www.macrodyneusa.com/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('MTA', 'Mehtatech', '', '', 'http://www.mehtatech.com/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('NPT', 'NxtPhase', '', '', 'http://www.nxtphase.com/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('OTR', 'Other / Unspecified', '', '', '')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('SEL', 'Schweitzer', '', '', 'http://www.selinc.com/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('TVA', 'TVA', '', '', 'http://www.tva.gov/')
INSERT INTO Vendor(Acronym, Name, PhoneNumber, ContactEmail, URL) VALUES('VT', 'Virginia Tech', '', '', 'http://www.vt.edu/')

INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(2, 'Arbiter-1133A', 'Arbiter 1133A Power Sentinel', 'http://www.arbiter.com/catalog/power/1133a/1133a.php')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(1, 'ABB-521', 'ABB RES521', 'http://library.abb.com/GLOBAL/SCOT/SCOT296.nsf/VerityDisplay/79B16E5CF206C79CC125712D0074AC6F/$File/1MRK511113-HEN_D_en_Phasor_Measurement_Terminal_RES_521.pdf')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(8, 'Mehtatech', 'Metha Tech Transcan 2000 IED', 'http://www.mehtatech.com/pdf/IEDbrochMay02b.pdf')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(7, 'Macrodyne', 'Macrodyne 1690', 'http://www.macrodyneusa.com/model_1690.htm')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(11, 'SEL-421', 'SEL-421 Relay', 'http://www.selinc.com/sel-421.htm')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(4, 'BPA PDC', 'Bonneville Power Administration', 'http://www.bpa.gov/')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(6, 'Hathaway IDM', 'Qualitrol Hathaway IDM Fault Recorder', 'http://www.qualitrolcorp.com/docs/home/IDM_Brochure.pdf')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(3, 'Ametek', 'Ametek TR-2000 Multi-Function Recorder', 'http://www.ametekpower.com/products/sku.cfm?SKU_Id=12328')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(9, 'NxtPhase', 'NxtPhase Telsa 2000 Fault Recorder', 'http://www.nxtphase.com/sub-products-relays-tesla-model-2000P.htm')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(10, 'Other', 'Other Device', '')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(11, 'SEL-5077', 'SEL-5077 SynchroWAVe Server Software', 'http://www.selinc.com/synchrowave.htm')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(11, 'SEL-451', 'SEL-451 Relay', 'http://www.selinc.com/sel-451.htm')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(11, 'SEL-3306', 'SEL-3306 Synchrophasor Processor', 'http://synchrophasor.selinc.com/')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(5, 'GE N60', 'GE N60 Synchrophasor Measurement System', 'http://www.geindustrial.com/cwc/products?pnlid=6&famid=31&catid=234&id=n60&lang=en_US')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(12, 'openPDC', 'TVA Open Source Phasor Data Concentrator', 'http://openPDC.codeplex.com/')
INSERT INTO VendorDevice(VendorID, Name, Description, URL) VALUES(13, 'FNET', 'Virginia Tech FNET Device', '')

INSERT INTO FundingSource (SourceName) VALUES ('Part of SGIG')
INSERT INTO FundingSource (SourceName) VALUES ('ARRA')
INSERT INTO FundingSource (SourceName) VALUES ('Self-Financed')

INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('AEP', 'AEP', 'American Electric Power', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('AGP', 'AGP', 'Allegheny Power', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('AMR', 'AMR', 'Ameren', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('ATC', 'ATC', 'American Transmission Company', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('BCH', 'BCH', 'British Columbia Hydro', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('BPA', 'BPA', 'Bonneville Power Administration', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('ConED', 'CED', 'ConEdison', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('EES', 'EES', 'Entergy Energy Services', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('EXE', 'EXE', 'Exelon Energy', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('FEN', 'FEN', 'First Energy', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('FPL', 'FPL', 'Florida Power & Light Company', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('HQC', 'HQC', 'Hydro Quebec', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('LIPA', 'LPA', 'Long Island Power Authority', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('LAWP', 'LWP', 'Los Angeles Dept of Water and Power', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('MDA', 'MDA', 'Ameritech', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('MDK', 'MDK', 'Montana-Dakota ', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('MISO', 'MSO', 'Midwest ISO', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('MTB', 'MTB', 'Manitoba Hydro', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('METC', 'MTC', 'Michigan Electric Transmission Co.', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('NYPA', 'NYP', 'New York Power Authority', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('DDL', 'DDL', 'Desired Device Locations', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('PPL', 'PPL', 'PPL Electric Utilities', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('PGE', 'PGE', 'Pacific Gas and Electric', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('PJM', 'PJM', 'PJM Interconnection', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('SCE', 'SCE', 'Southern California Edison', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('SOCO', 'SOC', 'Southern Company', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('SPP', 'SPP', 'Southwest Power Pool', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('SWT', 'SWT', 'Southwest (APS and SRP)', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('TVA', 'TVA', 'Tennessee Valley Authority', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('VT', 'VT ', 'Virginia Tech', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('WAPA', 'WPA', 'Western Area Power Administration', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('NEISO', 'NEI', 'New England ISO', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('MPC', 'MPC', 'Minnkota Power Collective', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('MAM', 'MAM', 'MidAmerican Power', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('HEC', 'HEC', 'Hawaiian Electric Company', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('OGE', 'OGE', 'Oklahoma Gas & Electric', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('ITC', 'ITC', 'International Transmission Company', '', 1, 1, 'Central Standard Time')
INSERT INTO Company(Acronym, MapAcronym, Name, URL, InterconnectionID, NercRegionID, TimeZone) VALUES('DUKE', 'DUK', 'Duke Power', '', 1, 1, 'Central Standard Time')